<%@ page import="java.sql.*" %><%--
  Created by IntelliJ IDEA.
  User: cc
  Date: 2020/10/7
  Time: 8:12
  To change this template use File | Settings | File Templates.
--%>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>个人中心</title>
    <%--引入 css文件 和 js文件--%>
    <link rel="stylesheet" href="css/bootstrap.css">

    <script src="js/jquery.min.js"></script>
    <script src="js/bootstrap.js"></script>
    <script src="js/bootstrap.bundle.js"></script>
    <style>
        .container{
            margin-top:20px;
        }
    </style>
</head>
<body>
<div cLass=”container">
    <div cLass="row clearfix">
        <div cLass="col-md-12 coLumn">
            <h3 styLe="text-align: center">欢迎来到个人主页！</h3>
            <a href="#modal-container-addUser" role="button" class="btn" data-toggle="modal">添加用户</a>
            <table cLass="table table-striped">
                <thead>
                <th>ID</th>
                <th>用户名</th>
                <th>性别</th>
                <th>年龄</th>
                <th>操作</th>
                </thead>
                <tbody>
    <%
                if (session.getAttribute("username") == null){
                    //表示尚未登录
                    out.print("你尚未登陆，3秒之后跳转登录页面");
                    response.setHeader("refresh", "3;url=login.jsp");
                } else {

                    //加载数据库驱动
                    Class.forName("com.mysql.jdbc.Driver");

                    //建立数据库连接
                    String url = "jdbc:mysql://localhost:3306/book";//数据库连接地址
                    Connection connection = DriverManager.getConnection(url, "root", "root");//第一个root为数据库的用户  第二个root为数据库的密码
                    String sql = "select * from user";//在 PreparedStatement 中使用问好代替实际参数
                    PreparedStatement ps = connection.prepareStatement(sql);

                    ResultSet rs = ps.executeQuery();

                    while (rs.next()) {
                        out.print("<tr>");
                        out.print(
                                "<td>" + rs.getInt("id")+"</td>"
                                        +"<td>"+rs.getString("username")+"</td>"
                                        +"<td>"+rs.getString("gender")+"</td>"
                                        +"<td>"+rs.getString("age")+"</td>"
                                        +"<td><a href='delete.jsp?id="+rs.getString("id")+"'>删除</a>"
                                        +"&nbsp;<a href='edit.jsp?id="+rs.getString("id")+"'>编辑</a></td>");
                        out.print("</tr>");
                    }
                }
                %>
                </tbody>
            </table>


            <div class="modal fade" id="modal-container-19371" role="dialog" aria-hidden="true" aria-labelledby="myModalLabel">
                <div class="modal-dialog">
                    <div class="modal-content">
                        <div class="modal-header">
                            <button class="close" aria-hidden="true" type="button" data-dismiss="modal">×</button>
                            <h4 class="modal-title" id="myModalLabel">添加用户</h4>
                        </div>
                        <form role="form" method="post" action="add.jsp"
                        <div class="modal-body">
                            <div class="form-group">
                                <label>用户名：</label><input type="text" name="username" class="form-control" />
                            </div>
                            <div class="form-group">
                                <label>密码：</label><input type="password" name="password" class="form-control" />
                            </div>
                            <div class="form-group">
                                <label>姓名：</label><input type="text" name="gender" class="form-control" />
                            </div>
                            <div class="form-group">
                                <label>性别：</label><input type="text" name="age" class="form-control" />
                            </div>
                        </div>
                        <div class="modal-footer">
                            <button class="btn btn-default" type="button" data-dismiss="modal">关闭</button>
                            <button class="btn btn-primary" type="submit">添加</button>
                        </div>
                    </div>

                </div>

            </div>
        </div>
    </div>
</div>

</body>
</html>


